Skip Headers

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Upgrading the Recovery Catalog

If you use a version of the recovery catalog that is older than that required by the RMAN client, then you must upgrade it. For example, you must upgrade the catalog if you use a release 8.1 version of the RMAN client with a release 8.0 version of the recovery catalog.

You receive an error when issuing `UPGRADE` `CATALOG` if the recovery catalog is already at a version greater than that required by the RMAN client. RMAN permits the `UPGRADE` `CATALOG` command to be run if the recovery catalog is current and does not require upgrading, however, so that you can re-create packages at any time if necessary. Check the message log for error messages generated during the upgrade.

To upgrade the recovery catalog:

1. To install the new recovery catalog schema, the recovery catalog user must have TYPE privilege:

       sqlplus> connect sys/oracle@catdb as sysdba;
       sqlplus> grant TYPE to rman;

2. Use RMAN to connect to the target and recovery catalog databases. For example, enter:

       % rman TARGET / CATALOG rman/cat@catdb

       connected to recovery catalog database
       PL/SQL package rcat.DBMS_RCVCAT version 08.00.04 in RCVCAT database
       is too old

3. Issue the `UPGRADE` `CATALOG` command:

       UPGRADE CATALOG;

       recovery catalog owner is rman
       enter UPGRADE CATALOG command again to confirm catalog upgrade

4. Enter the `UPDATE` `CATALOG` command again to confirm:

       UPGRADE CATALOG;

       recovery catalog upgraded to version 09.02.00
       DBMS_RCVMAN package upgraded to version 09.02.00
       DBMS_RCVCAT package upgraded to version 09.02.00

   See Also: Oracle Database Backup and Recovery Reference for `UPGRADE` `CATALOG` command syntax Oracle Database Backup and Recovery Reference for information about recovery catalog compatibility Oracle Database Upgrade Guide for complete compatibility and migration information